home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / revision.sql < prev    next >
Text File  |  2000-05-12  |  742b  |  20 lines
  1. /* RCSVER $Id: revision.sql,v 1.1 2000-02-08 14:47:22-06 randy Exp $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:    revision.sql
  6. * Date:        02/07/2000
  7. * memo:        Randy Wood
  8. * Description:    Create the revision table.
  9. * Changes:
  10. ************************************************************************* */
  11. CREATE TABLE revision
  12. (
  13.     det_seq_num    NUMBER(38)
  14.         CONSTRAINT ref1_revision REFERENCES mstrrec(det_seq_num),
  15.     farebox_glid    NUMBER(38),
  16.       conv_date       DATE,               /* Date for this record */
  17.     rev_num    VARCHAR2(20),        /* Software revision number */
  18.     rev_date    VARCHAR2(20)        /* Software revision date */
  19. );
  20.